﻿using System;
using System.Collections.Generic;
using System.Text;

namespace Coldairarrow.Util.Excel.Model
{
    [Serializable]
    public class SheetRule
    {
        /// <summary>
        /// Sheet名
        /// </summary>
        public string SheetName { get; set; } = string.Empty;
        /// <summary>
        /// 数据库表名
        /// </summary>
        public string DbTableName { get; set; } = string.Empty;
        /// <summary>
        /// 数据行开始行索引
        /// </summary>
        public int StartRowNum { get; set; } = 0;
        /// <summary>
        /// 数据行结束行索引
        /// </summary>
        public int EndRowNum { get; set; } = -1;
        /// <summary>
        /// 标题行开始索引
        /// </summary>
        public int RowHeadNum { get; set; } = 0;
        /// <summary>
        /// 标题行结束索引
        /// </summary>
        public int RowHeadEndNum { get; set; } = 0;
        /// <summary>
        /// 验证时是否分析头部标题
        /// （选填）
        /// </summary>
        public bool IsAnalyzeHead { get; set; } = false;
       
        /// <summary>
        /// 转换模式
        /// 0 为规则表格
        /// 1 为不规则表格
        /// </summary>
        public int ParseModel { get; set; } = 0;
        /// <summary>
        /// 列规则列表
        /// </summary>
        public List<ColumnRule> ColumRules { get; set; } = new List<ColumnRule>();
        
        /// <summary>
        /// Sheet页索引
        /// （选填）
        /// </summary>
        public int SheetIndex { get; set; } = -1;
      
    }
}
